package com.ctshk.rpc.booking.mapper;

import com.ctshk.rpc.booking.base.CustomBaseMapper;
import com.ctshk.rpc.booking.entity.SupplierOrder;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 统一供应商预订单 Mapper 接口
 * </p>
 *
 * @author 谢诗宏
 * @since 2021-03-09
 */
public interface SupplierOrderMapper extends CustomBaseMapper<SupplierOrder> {

    @Select("select so.id, so.confirm_status from t_supplier_order so where so.sale_number = #{saleNumber} and so.schedule_id is null")
    SupplierOrder selectSourceBySaleNumber(@Param("saleNumber") String saleNumber);
}
